He became the darling of Egypt and managed the country's coffers wisely during the years of drought